Next, we will create a Year Over Year (YOY) Total Properties & Total Sales by Township Scroller
Step 1 - Download Scroller Visual in the ZipCode dashboard
In Power BI Desktop, click on the page, ZipCode .
If you don't see the Scroller Visualizations under Visualizations, follow these steps to add it.
Under Visualizations, click on the Ellipsis (...) -> Import a Visual from a file -> browse to the extracted folder -> WakeCounty_Real_Estate_Property_Template and select Scroller.2.0.3.0.pbiviz
Note: Alternatively, you can download it from the AppSource.
To import a Scroller visual from AppSource, in the Visualizations pane, click on the Ellipsis (...), select the Get more visuals icon and then select Get more visuals. On the window that displays, locate (search) and select the Scroller visual that you want to import and then select Add.
Step 2 - Create Year Over Year (YOY) Total Properties by Township Scroller
Visualizations
Click the Scroller icon
Fields
Select the following:
Township -> Township_Name - Under Visualizations, drag & drop it in the Category section
A_KeyMeasures -> .Total_Properties - Under Visualizations, drag & drop it in the Measure Absolute section.
A_KeyMeasures -> .YOY_Total_Properties% - Under Visualizations, drag & drop it in the Measure Deviation section.
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Properties = Total Properties
.YOY_Total_Properties% = YOY Total Properties
Township_Name = Township Name
Under Format -> General: X Position = 362 , Y Position = 1029 , Width = 1134 , Height = 52
Under Format -> Scroller -> Auto-size font = OFF , Set Status Indicator to ON -> Font Size = 18 , Scroll Speed = 1 , TextColor = #FFFFFF , Background Color = #1D0C4A , Update Interval = 50
Under Format -> Title -> Set it to ON , Title Text = Year Over Year (YOY) Total Properties by Township , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to OFF
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px
Filters
None
Sort the Scroller by Township name in ascending order
Click on the Ellipsis (...), select Sort by = Township.
Click on the Ellipsis (...), select Sort ascending.
Step 3 - Create Year Over Year (YOY) Total Sales by Township Scroller in the Township dashboard
Visualizations
To create the following visual, copy and paste the Year Over Year (YOY) Total Properties by Township Scroller that was created in Step 2 and use it as a template.
To create a copy of the visual, click the Year Over Year (YOY) Total Properties by Township Scroller visualization , Click on the Township dashboard , press Ctrl+C to copy, and then press Ctrl+V to paste
Fields
Select the following:
Township -> Township_Name - Under Visualizations, drag & drop it in the Category section
A_KeyMeasures -> .Total_Sales_Properties - Under Visualizations, drag & drop it in the Measure Absolute section.
A_KeyMeasures -> .YOY_Total_Sales_Properties% - Under Visualizations, drag & drop it in the Measure Deviation section.
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Total_Sales_Properties = Total Sales
.YOY_Total_Sales_Properties% = YOY Total Sales
Township_Name = Township Name
Under Format -> General: X Position = 362 , Y Position = 1028 , Width = 1149 , Height = 52
Under Format -> Scroller -> Auto-size font = OFF , Set Status Indicator to ON -> Font Size = 18 , Scroll Speed = 1 , TextColor = #FFFFFF , Background Color = #1D0C4A , Update Interval = 50
Under Format -> Title -> Set it to ON , Title Text = Year Over Year (YOY) Total Sales by Township , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to OFF
Under Format -> Border -> Set it to ON , Color = 666666, Radius = 5 px
Sort the Scroller by Township name in ascending order
Click on the Ellipsis (...), select Sort by = Township.
Click on the Ellipsis (...), select Sort ascending.
Filters
None
It will look as follows when complete:
For more information on the Scroller or to download the Scroller used in this project: